Clear Region

Excel.ClearRange(objExcelWorkBook,sheet,strRange,bClearFormat,bSave)

Clear the specified region

Required Parameter: objExcelWorkBook--Excel workbook object (workbook opened with "Open Excel" command (Excel.OpenExcel)); sheet--If a string is used, it refers to the name of the specified sheet; if a number is used, it refers to the index of the specified sheet (starting from 0); strRange--The specified cell, supports two forms: cell names (such as "A1:B2") or two-dimensional array of rows and columns (such as [[cell1 Row number, cell1 column number],[cell2 Row number, cell2 column number]]). When using cell names, it is case insensitive; bClearFormat--Whether to clear format of the selected region; bSave--Save immediately after an operation

results matching ""